SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO


CREATE PROCEDURE dbo.[DnnProduct_CDS_CurrencyUpdate]
	@ID int,
	@Name nvarchar(256),
    @CurrencySymbol [nvarchar](40),
    @ISOCode [varchar](3),
    @ExchangeRate [decimal](12, 4),
    @LastUpdated [datetime],
    @Provider [nvarchar](256)
AS
BEGIN
	UPDATE [DnnProduct_CDS_Currencies]
	SET [Name] = @Name,
      [CurrencySymbol] = @CurrencySymbol,
      [ISOCode] = @ISOCode,
      [ExchangeRate] = @ExchangeRate,
      [LastUpdated] = @LastUpdated,
      [Provider] = @Provider
	WHERE [ID] = @ID
END
GO
